Tool for shifting tables from Mysql to Postgresql

Dear all,

I want to convert some tables from Mysql database to Postgresql Database
in Linux Systems ( Ubuntu-10.4, CentOS ).

Can someone Please tell me tool for it that makes it easier.

I am able to done it through FW tools in Windows System but i want to
achieve it in Linux ( CentOS ) System.

I researched a lot & tried below steps :

1. mysqldump --compatible=postgresql wiki20100130 >
/hdd4-1/wiki20100130_mysql108feb22.sql

2. sed "s/\\\'/\'\'/g" wiki20100130_mysql108feb22.sql

3. bin/psql -Upostgres wiki20100130 < /hdd4-1/wiki20100130_mysql108feb22.sql

invalid byte sequence for encoding "UTF8": 0xe3ba27
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
ERROR: invalid byte sequence for encoding "UTF8": 0xee6c65
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
ERROR: invalid byte sequence


I think a tool would ease that work.

Thanks & best Regards,

Adarsh Sharma

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Tool for shifting tables from Mysql to Postgresql

2011/3/1 Adarsh Sharma :
> Dear all,
>
> I want to convert some tables from Mysql database to Postgresql Database =
in
> Linux Systems ( Ubuntu-10.4, CentOS ).
[...]
> invalid byte sequence for encoding "UTF8": 0xe3ba27
> HINT:  This error can also happen if the byte sequence does not matc=
h the
> encoding expected by the server, which is controlled by "client_encoding"=
..
> ERROR:  invalid byte sequence for encoding "UTF8": 0xee6c65
> HINT:  This error can also happen if the byte sequence does not matc=
h the
> encoding expected by the server, which is controlled by "client_encoding"=
..
> ERROR:  invalid byte sequence

This is not a MySQL-specific error. You are using a character set
encoding as if it were another. Please, check documentation for the
options to export and import database dumps such as:

ault-character-set>

--=20
Jaime Crespo
MySQL & Java Instructor
Software Developer
Warp Networks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Tool for shifting tables from Mysql to Postgresql

By default Postgresql database encoding in UTF8.

It seems to me by seeing error that database encoding in mysql is
different from it.


--
Cheers,
Dhaval Jaiswal




On 01/03/2011 3:57 PM, Adarsh Sharma wrote:
> Dear all,
>
> I want to convert some tables from Mysql database to Postgresql
> Database in Linux Systems ( Ubuntu-10.4, CentOS ).
>
> Can someone Please tell me tool for it that makes it easier.
>
> I am able to done it through FW tools in Windows System but i want to
> achieve it in Linux ( CentOS ) System.
>
> I researched a lot & tried below steps :
>
> 1. mysqldump --compatible=postgresql wiki20100130 >
> /hdd4-1/wiki20100130_mysql108feb22.sql
>
> 2. sed "s/\\\'/\'\'/g" wiki20100130_mysql108feb22.sql
>
> 3. bin/psql -Upostgres wiki20100130 <
> /hdd4-1/wiki20100130_mysql108feb22.sql
>
> invalid byte sequence for encoding "UTF8": 0xe3ba27
> HINT: This error can also happen if the byte sequence does not match
> the encoding expected by the server, which is controlled by
> "client_encoding".
> ERROR: invalid byte sequence for encoding "UTF8": 0xee6c65
> HINT: This error can also happen if the byte sequence does not match
> the encoding expected by the server, which is controlled by
> "client_encoding".
> ERROR: invalid byte sequence
>
>
> I think a tool would ease that work.
>
> Thanks & best Regards,
>
> Adarsh Sharma
>
This e-mail, and any attachments are strictly confidential and may also contain legally privileged information. It is intended for the addressee(s) only. If you are not the intended recipient, please do not print, copy, store or act in reliance on the e-mail or any of its attachments. Instead, please notify the sender immediately and then delete the e-mail and any attachments.

Unless expressly stated to the contrary, the views expressed in this e-mail are not necessarily the views of Enzen Global Solutions (P) Limited or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees makes no representation and accept no liability for the accuracy or completeness of this e-mail. You are responsible for maintaining your own virus protection and the Group Companies do not accept any liability for viruses. Enzen reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Enzen e-mail system.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Tool for shifting tables from Mysql to Postgresql

--20cf307abea9847ff5049d6a802b
Content-Type: text/plain; charset=ISO-8859-1

Hi Adarsh,

There are very good tools out for migration from Mysql to PostgreSQL.
EnterpriseDB has the migration studio which will help to migrate Mysql to
PostgreSQL.

http://www.enterprisedb.com/solutions/mysql-vs-postgresql/ho w-to-move-from-mysql-to-postgresql

Best Regards,
Raghavendra
EnterpriseDB Corporation

On Tue, Mar 1, 2011 at 3:57 PM, Adarsh Sharma wrote:

> Dear all,
>
> I want to convert some tables from Mysql database to Postgresql Database in
> Linux Systems ( Ubuntu-10.4, CentOS ).
>
> Can someone Please tell me tool for it that makes it easier.
>
> I am able to done it through FW tools in Windows System but i want to
> achieve it in Linux ( CentOS ) System.
>
> I researched a lot & tried below steps :
>
> 1. mysqldump --compatible=postgresql wiki20100130 >
> /hdd4-1/wiki20100130_mysql108feb22.sql
>
> 2. sed "s/\\\'/\'\'/g" wiki20100130_mysql108feb22.sql
>
> 3. bin/psql -Upostgres wiki20100130 <
> /hdd4-1/wiki20100130_mysql108feb22.sql
>
> invalid byte sequence for encoding "UTF8": 0xe3ba27
> HINT: This error can also happen if the byte sequence does not match the
> encoding expected by the server, which is controlled by "client_encoding".
> ERROR: invalid byte sequence for encoding "UTF8": 0xee6c65
> HINT: This error can also happen if the byte sequence does not match the
> encoding expected by the server, which is controlled by "client_encoding".
> ERROR: invalid byte sequence
>
>
> I think a tool would ease that work.
>
> Thanks & best Regards,
>
> Adarsh Sharma
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--20cf307abea9847ff5049d6a802b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Adarsh,